Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
DenominationID (PK) | An identifier which uniquely identifies the quantitative value of a specific currency, e.g. $100, �50, etc. | ID_DNM | Identity | integer | |
ISOCurrencyCode (FK)(PK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |
Description | A description of the quantitative value of a specific currency. | NM_DNM | Name | varchar(40) | |
MonetaryValueAmount | The monetary value expressed as a fraction or multiple of the base currency. For a EURO this could be a 1 for a 1 Euronote. For a DOLLAR this could be $.25 for quarter. This value is used when counting currency denominations as part of the tender settlement process for TILLS. | MO_AMT | MoneyShortRetail | decimal(7,2) | |